package com.sudo.dao.admin.mapper;

import com.sudo.common.mapper.MyMapper;
import com.sudo.dao.admin.entity.SysUserLoginRecord;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface SysUserLoginRecordMapper extends MyMapper<SysUserLoginRecord> {

    @Select("<script>" +
            "select count(distinct username) from sys_user_login_record " +
            "where loginTime <![CDATA[ >= ]]> concat(#{startDay},' 00:00:00') " +
            "and loginTime <![CDATA[ <= ]]> concat(#{endDay},' 23:59:59') " +
            "</script>")
    int selectUserNopCountByDay(@Param("startDay") String startDay,@Param("endDay") String endDay);
}
